﻿CREATE TABLE [dbo].[AdClick]
(
	[ClickId] INT NOT NULL PRIMARY KEY IDENTITY, 
    [AdId] INT NULL, 
    [AppId] INT NULL, 
    [Username] VARCHAR(200) NULL, 
    [Time] DATETIME NULL, 
    [Source] VARCHAR(256) NULL, 
    [Language] VARCHAR(5) NULL, 
    CONSTRAINT [FK_AdClick_Ad] FOREIGN KEY ([AdId]) REFERENCES [Ad]([AdId]), 
    CONSTRAINT [FK_AdClick_App] FOREIGN KEY ([AppId]) REFERENCES [App]([AppId])
)
